求高手指教EXCEL如何用VBA在工作簿中查找包含某字段的行?答:代码如下:Sub ErCiShangXianFenLei() Dim i As Long, arr, m As Integer, n As Integer arr = Array("ASP", "SW", "S29", "SP", "BWS", "CWS", "JPP", "QSP") With Sheets("Sheet1") .[a1].Resize(, 8).Copy Sheets("Sheet2").[a1] For i = 2 To ....